package net.youpo.Market.db;

import java.lang.ref.SoftReference;

import android.graphics.Bitmap;

public class MessageTable {
    public static final String TABLE_NAME = "Message";
    public static final String ID = "_id";
    public static final String MESSAGEID = "_messageId"; // 推送的消息id
    public static final String APPID = "_appId";// 推送的应用id
    public static final String TIME = "_time";// 推送的时间
    public static final String NAME = "_appName";// 推送的时间
    public static final String ICON = "_icon";
    public static final String DOWNLOAD_COUNT = "_dCount";
    public static final String AUTHOR = "_author";
    public static final String PUCKAGE_NAME = "_pName";
    public static final String VERSION_NAME = "_vName";
    public static final String VERSION_CODE = "_vCode";
    public static final String SIZE = "_size";
    public static final String DESE = "_dese";
    public static final String CAT = "_cat";
    public static final String DOWNLOAD_LINE = "_dLine";
    public static final String IMAGE_URL = "_ImageUrl";

    public static final String sql = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME
            + " (" + ID
            + " INTEGER DEFAULT '1' NOT NULL PRIMARY KEY AUTOINCREMENT,"
            + MESSAGEID + " VARCHAR," + APPID + " VARCHAR," + NAME
            + " VARCHAR," + TIME + " VARCHAR," + ICON + " VARCHAR,"
            + DOWNLOAD_COUNT + " VARCHAR," + AUTHOR + " VARCHAR,"
            + PUCKAGE_NAME + " VARCHAR," + VERSION_NAME + " VARCHAR,"
            + VERSION_CODE + " VARCHAR," + SIZE + " VARCHAR," + DESE
            + " VARCHAR," + CAT + " VARCHAR," + DOWNLOAD_LINE + " VARCHAR,"
            + IMAGE_URL + " VARCHAR" + ")";
}
